package com.WaVel.mapper;


import com.Emplyment.entity.InterView;
import com.Emplyment.vo.CommentVo;
import com.Emplyment.vo.InterViewVo;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface InterviewDiscussionMapper {


    List<InterViewVo> getInterviewArticles(String category);

    @Select("SELECT * FROM comment WHERE interviewId = #{interviewId}")
    List<CommentVo> getComments(int interviewId);

    @Delete("DELETE from comment where id = #{id}")
    void deleteInterviewComment(int id);

    @Delete("DELETE from interview where interviewId = #{id}")
    void deleteInterviewArticle(int id);

    @Delete("DELETE from comment where interviewId = #{id}")
    void deleteComments(int id);
}
